<?php

class AccountReceivableController extends Controller {
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	//public $layout='//layouts/column2';

	/**
	 * @return array action filters
	 */
	public function filters() {
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules() {
		return array(
			array(
				'allow',
				// allow all users to perform 'index' and 'view' actions
				'actions' => array(
					'index',
					'view',
					'indexStatistic',
				),
				'roles' => array(
					'accountView'
				),
			),
			array(
				'allow',
				// allow admin user to perform 'admin' and 'delete' actions
				'actions' => array(
					'create',
					'update',
					'admin',
					'delete'
				),
				'roles' => array(
					'accountManage'
				),
			),
			array(
				'deny',
				// deny all users
				'users' => array(
					'*'
				),
			),
		);
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id) {
		$this->render('view', array(
				'model' => $this->loadModel($id),
			));
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate() {
		$model = new AccountReceivable;

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if (isset($_POST['AccountReceivable'])) {
			$model->attributes = $_POST['AccountReceivable'];
			if ($model->save())
				$this->redirect(array(
						'view',
						'id' => $model->id
					));
		}

		$this->render('create', array(
				'model' => $model,
			));
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id) {
		$model = $this->loadModel($id);

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if (isset($_POST['AccountReceivable'])) {
			$model->attributes = $_POST['AccountReceivable'];
			if ($model->save())
				$this->redirect(array(
						'view',
						'id' => $model->id
					));
		}

		$this->render('update', array(
				'model' => $model,
			));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id) {
		if (Yii::app()->request->isPostRequest) {
			// we only allow deletion via POST request
			$this->loadModel($id)->delete();

			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
			if (!isset($_GET['ajax']))
				$this
					->redirect(
						isset($_POST['returnUrl']) ? $_POST['returnUrl']
							: array(
								'admin'
							));
		} else
			throw new CHttpException(400,
				'Invalid request. Please do not repeat this request again.');
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex() {
		$searchModel = new AccountReceivableSearch();
		$searchModel->unsetAttributes(); // clear any default values
		if (isset($_GET['AccountReceivableSearch'])) {
			$searchModel->attributes = $_GET['AccountReceivableSearch'];
		}
		$model = clone AccountReceivable::model();
		if (AccessControl::isAltMode()) {
			$model->altMode();
		}
		$model->getDbCriteria()->mergeWith($searchModel->createCriteria($model->getTableAlias()));
		$dataProvider = new CActiveDataProvider($model);
		$this
			->render('index',
				array(
					'dataProvider' => $dataProvider,
					'searchModel' => $searchModel,
				));
	}

	public function actionIndexStatistic() {
		$searchModel = new AccountReceivableSearch();
		if (isset($_POST['AccountReceivableSearch'])) {
			$searchModel->attributes = $_POST['AccountReceivableSearch'];
		}
		$model = AccountReceivable::model();
		$criteria = $searchModel->createCriteria($model->getTableAlias(), true);
		$criteria->select = 'sum(price) as totalPrice,
		                max(price) as maxPrice, min(price) as minPrice
		                ';
		$commandBuilder = Yii::app()->db->getSchema()->getCommandBuilder();
		$command = $commandBuilder->createFindCommand($model->getTableSchema(), $criteria);
		$row = $command->queryRow();

		$formatter = Yii::app()->format;
		$result = array(
			'totalPrice' => $formatter->formatCurrency($row['totalPrice']),
			'maxPrice' => $formatter->formatCurrency($row['maxPrice']),
			'minPrice' => $formatter->formatCurrency($row['minPrice']),
		);

		JHtml::jsonHeader();
		echo CJSON::encode($result);
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin() {
		$model = new AccountReceivable('search');
		$model->unsetAttributes(); // clear any default values
		if (isset($_GET['AccountReceivable']))
			$model->attributes = $_GET['AccountReceivable'];

		if (AccessControl::isAltMode()) {
			$model->altMode = 1;
		}
		$this->render('admin', array(
				'model' => $model,
			));
	}

	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id) {
		$model = AccountReceivable::model()->findByPk($id);
		if ($model === null || (AccessControl::isAltMode() && $model->altMode))
			throw new CHttpException(404, 'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model) {
		if (isset($_POST['ajax']) && $_POST['ajax'] === 'account-receivable-form') {
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
}
